Installing the libraries that are needed to be able to load and preform queries on the dataset.

library(DataComputing)
library(tidyverse)
library(rvest)
library(lubridate)
library(dplyr)
library(readr)
library(ggplot2)

Load Data

Getting the tables into RStudio to be able to use them for evaluation. We will do this using the read functions.

file_name <- file.choose()
sampleSubmission <- data.table::fread(file_name)
sampleSubmission
file_name <- file.choose()
TrainData <- data.table::fread(file_name)
Some columns are type 'integer64' but package bit64 is not installed. Those columns will print as strange looking floating point data. There is no need to reload the data. Simply install.packages('bit64') to obtain the integer64 print method and print the data again.
TrainData
file_name <- file.choose()
TestData <- data.table::fread(file_name)
Some columns are type 'integer64' but package bit64 is not installed. Those columns will print as strange looking floating point data. There is no need to reload the data. Simply install.packages('bit64') to obtain the integer64 print method and print the data again.
TestData

Tidy Data – Wrangling

LS0tCnRpdGxlOiAiUHJvamVjdCBQaGFzZSAyIiAKc3VidGl0bGU6ICJEUzMxMCIKYXV0aG9yOiAiQXJ3YSBIYXJhcndhbGEsIEtyaXRoaWthIFNlbnRoaWwsICYgU3dhcmFsaSBLb3JnYW9ua2FyIgpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sKLS0tCgpJbnN0YWxsaW5nIHRoZSBsaWJyYXJpZXMgdGhhdCBhcmUgbmVlZGVkIHRvIGJlIGFibGUgdG8gbG9hZCBhbmQgcHJlZm9ybSBxdWVyaWVzIG9uIHRoZSBkYXRhc2V0LgpgYGB7cn0KbGlicmFyeShEYXRhQ29tcHV0aW5nKQpsaWJyYXJ5KHRpZHl2ZXJzZSkKbGlicmFyeShydmVzdCkKbGlicmFyeShsdWJyaWRhdGUpCmxpYnJhcnkoZHBseXIpCmxpYnJhcnkocmVhZHIpCmxpYnJhcnkoZ2dwbG90MikKYGBgCgoKIyMjIExvYWQgRGF0YQpHZXR0aW5nIHRoZSB0YWJsZXMgaW50byBSU3R1ZGlvIHRvIGJlIGFibGUgdG8gdXNlIHRoZW0gZm9yIGV2YWx1YXRpb24uIFdlIHdpbGwgZG8gdGhpcyB1c2luZyB0aGUgcmVhZCBmdW5jdGlvbnMuIApgYGB7cn0KZmlsZV9uYW1lIDwtIGZpbGUuY2hvb3NlKCkKc2FtcGxlU3VibWlzc2lvbiA8LSBkYXRhLnRhYmxlOjpmcmVhZChmaWxlX25hbWUpCnNhbXBsZVN1Ym1pc3Npb24KYGBgCgpgYGB7cn0KZmlsZV9uYW1lIDwtIGZpbGUuY2hvb3NlKCkKVHJhaW5EYXRhIDwtIGRhdGEudGFibGU6OmZyZWFkKGZpbGVfbmFtZSkKVHJhaW5EYXRhCmBgYAoKCgpgYGB7cn0KZmlsZV9uYW1lIDwtIGZpbGUuY2hvb3NlKCkKVGVzdERhdGEgPC0gZGF0YS50YWJsZTo6ZnJlYWQoZmlsZV9uYW1lKQpUZXN0RGF0YQpgYGAKCiMjIyBUaWR5IERhdGEgLS0gV3JhbmdsaW5nIAo=